| SaPrintRegBillReportWork |
| Logical Entity Name | SaPrintRegBillReportWork |
| Default Table Name | SaPrintRegBillReportWork |
| Physical Only | NO |
| Definition | |
| Note |
| SaPrintRegBillReportWork Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
SaPrintRegBillReportWorkID |
int | NO | ||
| BatchId | varchar(32) | YES | ||
| RepType | char(1) | YES | ||
| SyStudentID | int | YES | ||
| StuNum | char(10) | YES | ||
| StudentName | varchar(100) | YES | ||
| NameStudent | varchar(100) | YES | ||
| StudentAddr | varchar(255) | YES | ||
| StudentCity | varchar(25) | YES | ||
| StudentState | varchar(25) | YES | ||
| StudentZip | varchar(25) | YES | ||
| StudentPhone | varchar(25) | YES | ||
| SchoolName | varchar(75) | YES | ||
| SchAddr | varchar(255) | YES | ||
| SchCity | varchar(25) | YES | ||
| SchState | varchar(25) | YES | ||
| SchZip | varchar(25) | YES | ||
| CampusPhone | varchar(25) | YES | ||
| AdEnrollID | int | YES | ||
| AdEnrollIDConnect | int | YES | ||
| PrintID | varchar(20) | YES | ||
| ProgramVersion | varchar(120) | YES | ||
| ExpStartDate | datetime | YES | ||
| ArBalance | money | YES | ||
| ProgramVersionConnect | varchar(120) | YES | ||
| GradDate | datetime | YES | ||
| EstimatedFunding | money | YES | ||
| ExpStartDateConnect | datetime | YES | ||
| Charges | money | YES | ||
| PendingCharges | money | YES | ||
| GradDateCOnnect | datetime | YES | ||
| SyCampusID | int | YES | ||
| StudentStatusCode | varchar(10) | YES | ||
| StudentStatusDescrip | varchar(100) | YES | ||
| PrintOverallBalance | bit | YES | ||
| PrintClassSchedule | bit | YES | ||
| PrintPaymentDueDate | bit | YES | ||
| PaymentDueDate | datetime | YES | ||
| PrintAddDropDate | int | YES | ||
| AddDropDate | datetime | YES | ||
| PrintExpFunding | bit | YES | ||
| ExpFundingTermCode | varchar(50) | YES | ||
| ExpFundingTerm | varchar(100) | YES | ||
| StatementComment | varchar(500) | YES | ||
| RegistrationComment | varchar(500) | YES | ||
| PrintStudentAddress | bit | YES | ||
| PrintEnrollmentInfo | bit | YES | ||
| Addr1 | varchar(255) | YES | ||
| City | varchar(25) | YES | ||
| State | varchar(25) | YES | ||
| Zip | varchar(25) | YES | ||
| Country | varchar(50) | YES | ||
| ScheduleAdTermID | int | YES | ||
| Term | varchar(100) | YES | ||
| StartDate | datetime | YES | ||
| AdTermID | int | YES | ||
| BillingMethod | varchar(10) | YES | ||
| BillingMethodDescrip | varchar(100) | YES | ||
| PrintLedgerCard | bit | YES | ||
| PrintSubsidiary | bit | YES | ||
| AcctStatus | varchar(100) | YES | ||
| CreditCardList | varchar(500) | YES | ||
| PmtPerDates | varchar(100) | YES | ||
| FaStudentAyPaymentPeriodId | int | YES | ||
| TotalAid | money | YES | ||
| TotalCharges | money | YES | ||
| PmtPerDatesConnect | varchar(100) | YES | ||
| AcctStatusConnect | varchar(100) | YES | ||
| FaStudentAyPaymentPeriodIdConnect | int | YES | ||
| TotalPayments | money | YES | ||
| TotalDiscounts | money | YES | ||
| TotalPendingCharges | money | YES | ||
| SaBillingStatementBatchStudentID | int | YES | ||
| AdTermList | varchar(8000) | YES | ||
| TransDate | varchar(50) | YES | ||
| CurrencySymbol | varchar(10) | YES | ||
| CurrencySymbolPosition | tinyint | YES | ||
| SySchoolName | varchar(255) | YES | ||
| CampusDescrip | varchar(100) | YES | ||
| PrintIDonReport | varchar(20) | YES | ||
| CampusDescripConnect | varchar(100) | YES | ||
| StudentStatusCodeConnect | varchar(255) | YES | ||
| StudentStatusDescripConnect | varchar(255) | YES | ||
| BillingMethodConnect | varchar(255) | YES | ||
| BillingMethodDescripConnect | varchar(255) | YES | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| UserId | int | NO | ||
| ts | timestamp | NO | ||
| FromTransDate | char(10) | YES | ||
| ToTransDate | char(10) | YES |
| SaPrintRegBillReportWork Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK__SaPrintR__C72DB0C638115483 | PrimaryKey | SaPrintRegBillReportWorkID |
| SaPrintRegBillReportWork Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| SaPrintRegBillReportWork Check Constraints |
| Check Constraint Name | CheckConstraint |